How to: Format numbers as currency on a form.
Solution:
In the Form Design view, select the desired control, select the 'View' menu and select 'Properties'. Select the 'Format' tab from the property sheet, and select 'Currency' from the 'Format' drop-down list.
NOTE: The data type must have already been defined in the Table Design view as either currency or number.
1) If the Database window is not active, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in the Design view and the floating Toolbox appears.)
5) Click to select the desired control. (Handles appear around the control.)
Handles appear around selected controls
6) Select the 'View' menu and select 'Properties'. (The property sheet appears for the selected control.)
7) Click the 'Format' tab.
Property sheet, Format tab
8) Click in the 'Format' box. (A down arrow appears.)
9) Select the down arrow. (A drop-down list appears.)
10) Select the 'Currency' option from the drop-down list.
NOTE: If 'Currency' is not available as an option, the data type is not defined as either currency or number in the Table Design view.
Select currency
11) To close the property sheet, click the 'X' in the upper-right hand corner of the property sheet.
Click X button to close property sheet
NOTE: The properties will be saved only when the design view is saved.
